TYPE=VIEW
query=select `luanvan`.`hknks`.`id` AS `id`,`luanvan`.`hknks`.`hknk` AS `hknk`,`luanvan`.`hknks`.`ngaybdhk` AS `ngaybdhk`,`luanvan`.`hknks`.`ngaykthk` AS `ngaykthk`,((to_days(`luanvan`.`hknks`.`ngaykthk`) - to_days(`luanvan`.`hknks`.`ngaybdhk`)) / 7) AS `sotuan` from `luanvan`.`hknks`
md5=805e3d91122397a1364383e61faf84f7
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=2
timestamp=2011-02-14 15:32:58
create-version=1
source=select `luanvan`.`hknks`.`id` AS `id`,\n    `luanvan`.`hknks`.`hknk` AS `hknk`,\n    `luanvan`.`hknks`.`ngaybdhk` AS `ngaybdhk`,\n    `luanvan`.`hknks`.`ngaykthk` AS `ngaykthk`,\n    ((to_days(`luanvan`.`hknks`.`ngaykthk`) - to_days(`luanvan`.`hknks`.`ngaybdhk`)) / 7) AS `sotuan` \nfrom `luanvan`.`hknks` \nWITH CASCADED CHECK OPTION
client_cs_name=utf8
connection_cl_name=utf8_unicode_ci
view_body_utf8=select `luanvan`.`hknks`.`id` AS `id`,`luanvan`.`hknks`.`hknk` AS `hknk`,`luanvan`.`hknks`.`ngaybdhk` AS `ngaybdhk`,`luanvan`.`hknks`.`ngaykthk` AS `ngaykthk`,((to_days(`luanvan`.`hknks`.`ngaykthk`) - to_days(`luanvan`.`hknks`.`ngaybdhk`)) / 7) AS `sotuan` from `luanvan`.`hknks`
